Skip Headers

Oracle® Access Manager for AS/400 Installation and User's Guide 10g Release 2 (10.2) for IBM iSeries OS/400 Part Number B16223-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# B National Language Support

This appendix documents the National Language Support (NLS) for the Access Manager. The following topics are included:

- Access Manager NLS Support

- Oracle Character Set Names

- Oracle NLS_LANG Specifications

## B.1 Access Manager NLS Support

The Access Manager is designed to support a multitude of single-byte character sets. Source files containing SQL packages can be written in any of the coded character set identifiers (CCSID) that are listed in Table B-1. The Access Manager does not support double-byte character sets as the underlying IBM ARD interface does not support those character sets.

## B.2 Oracle Character Set Names

In the table are the Oracle character set names that can be included as the third part of an Oracle NLS language specification. The Oracle language specification can be explicitly set for an invocation of the Access Manager by having access to a data area named `NLS_LANG`.

Table B-1 Oracle Character Set Names

CCSID | Oracle Character Set Name
--- | ---
37 | `WE8EBCDIC37`
273 | `D8EBCDIC273`
277 | `DKEBCDIC277`
278 | `S8EBCDIC278`
280 | `I8EBCDIC280`
284 | `WE8EBCDIC284`
285 | `WE8EBCDIC285`
297 | `F8EBCDIC297`
500 | `WE8EBCDIC500`
838 | `TH8TISEBCDIC`
870 | `EE8EBCDIC870`
875 | `EL8EBCDIC875`
1140 | `WE8EBCDIC1140`
1141 | `D8EBCDIC1141`
1142 | `DK8EBCDIC1142`
1143 | `S8EBCDIC1143`
1144 | `I8EBCDIC1144`
1145 | `WE8EBCDIC1145`
1146 | `WE8EBCDIC1146`
1147 | `F8EBCDIC1147`
1148 | `WE8EBCDIC1148`

The `NLS_LANG` data area that is shipped with the Access Manager defaults to `AMERICAN_AMERICA``.WE8EBCDIC37`. All data emanating from a SQL package is data to be transmitted from the AS/400 to the Oracle Database. This data is translated from the character set that is associated with the CCSID of the package to the character set that is denoted explicitly by `NLS_LANG` or by the default for `NLS_LANG`. Data that is returned from the Oracle server to the AS/400 is translated by the IBM Application Requester Driver API.

## B.3 Oracle NLS_LANG Specifications

An Oracle NLS_LANG specification includes three parts:

1. a language

2. a territory

3. a character set

For example:

    language_territory.character set
    AMERICAN_AMERICA.D8EBCDIC1141

For the Access Manager, the language is AMERICAN, and the territory is AMERICA. The error messages are currently in American English only. The third part is the Oracle character set name from Table B-1. The `NLS_LANG` values in Table B-2 are currently supported:

Table B-2 Oracle NLS_LANG Values

Language | Setting for language_territory.charset
--- | ---
Austrian/German | `AMERICAN_AMERICA.D8EBCDIC273` and `AMERICAN_AMERICA.D8EBCDIC1141`
Danish/Norwegian | `AMERICAN_AMERICA.DK8EBCDIC277` and `AMERICAN_AMERICA.DK8EBCDIC1142`
Eastern European | `AMERICAN_AMERICA.EE8EBCDIC870`
Finnish/Swedish | `AMERICAN_AMERICA.S8EBCDIC278` and `AMERICAN_AMERICA S8EBCDIC1143`
French | `AMERICAN_AMERICA.F8EBCDIC297` and `AMERICAN_AMERICA F8EBCDIC1147`
Greek | `AMERICAN_AMERICA.EL8EBCDIC875`
Italian | `AMERICAN_AMERICA.I8EBCDIC280` and `AMERICAN_AMERICA I8EBCDIC1144`
Thai | `AMERICAN_AMERICA.TH8TISEBCDIC`
Western European | `AMERICAN_AMERICA.WE8EBCDIC37` and `AMERICAN_AMERICA WE8EBCDIC1140`
Western European | `AMERICAN_AMERICA.WE8EBCDIC500` and `AMERICAN_AMERICA WE8EBCDIC1148`

Each user can have its own `NLS_LANG` data area. To change the `NLS_LANG` data area, change the Access Manager NLS language parameter by using the `CHGSQLDFLT` command as described in Chapter 6, "Configuring Access Manager".